SELECT Style_ID FROM TB_Styles
	

			select * from web_category_mappings where url='snowboarding' or url='/snowboarding'
			

			select * from application.getWebTaxonomy where upper(web_url)=?  and sort_position<>'NO'
			

			select web_url from application.getWebTaxonomy where upper(dept)='SNOWBOARDING' and typ='EMPTY'
			

			select web_url from application.getWebTaxonomy where upper(dept)='SNOWBOARDING' and typ='EMPTY'
		  

					select * from application.getWebTaxonomy where dept='Snowboarding' and typ<>'EMPTY' and subtyp_1='EMPTY' and sort_position<>'NO' order by sort_position desc
					

		    SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS
		    FROM tcontent
		    WHERE (parentID = '5EDE742B-D1F6-C174-A8E6A359B018AAD9') and (urltitle = 'snowboarding') AND (active = 1) AND ( (display = 1) or (display=2 and displaystart<='2024-10-14 11:21:27.0' and displaystop>='2024-10-14 11:21:27.0') 
		    )
		

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '5EDE742B-D1F6-C174-A8E6A359B018AAD9') AND (active = 1) AND display > 0
        

		select dept, typ, subtyp_1, subtyp_2, subtyp_3,category_style from application.getWebTaxonomy where 
		
			dept='Snowboarding' 	
		order by dept asc, typ asc, subtyp_1 asc, subtyp_2 asc, subtyp_3 asc
		

			select dept, typ, subtyp_1, subtyp_2, subtyp_3, active, web_url, category_style from application.getWebTaxonomy where 
			
			
					dept='Snowboarding'
					and typ<>'EMPTY'
					and subtyp_1='EMPTY'
				
			
			order by sort_position
			

		SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(attr1list) as attr1list
		, max(famlist) as famlist
		, max(sizelist) as sizelist
		, max(name) as name
		, max(gender) as gender
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		, max(of1) as of1
        , max(of2) as of2
        , max(of3) as of3
        , max(of4) as of4
        , max(of5) as of5
        , max(of6) as of6
        , max(of7) as of7
        , max(of8) as of8
        , max(of9) as of9
        , max(of10) as of10
		, max(of11) as of11
		, max(of12) as of12
		, max(of13) as of13
		, max(of14) as of14
		, max(of15) as of15
		, max(of16) as of16
		, max(of17) as of17
		, max(of18) as of18
		, max(of19) as of19
		, max(of20) as of20
        , max(WEB_OF1) as WEB_OF1
        , max(WEB_OF2) as WEB_OF2
        , max(WEB_OF3) as WEB_OF3
        , max(WEB_OF4) as WEB_OF4
        , max(WEB_OF5) as WEB_OF5
        , max(WEB_OF6) as WEB_OF6
        , max(WEB_OF7) as WEB_OF7
        , max(WEB_OF8) as WEB_OF8
        , max(WEB_OF9) as WEB_OF9
        , max(WEB_OF10) as WEB_OF10
        , max(WEB_OF11) as WEB_OF11
        , max(WEB_OF12) as WEB_OF12 
        , max(WEB_OF13) as WEB_OF13
        , max(WEB_OF14) as WEB_OF14
        , max(WEB_OF15) as WEB_OF15
        , max(WEB_OF16) as WEB_OF16
        , max(WEB_OF17) as WEB_OF17
        , max(WEB_OF18) as WEB_OF18
        , max(WEB_OF19) as WEB_OF19
        , max(WEB_OF20) as WEB_OF20
		
		FROM [dbo].[web_all_products] WHERE pictureid is not null and (realname NOT LIKE 'Pit Viper%Sunglasses%' )

		
			and ltrim(rtrim(dept))='Snowboarding'
            and ltrim(rtrim(typ)) = 'EMPTY' 
								and (
								
									upper(Sizelist) LIKE '%11%' 
									
										or 
									
									upper(Sizelist) LIKE '%6|7%' 
									
										or 
									
									upper(Sizelist) LIKE '%6%' 
									
										or 
									
									upper(Sizelist) LIKE '%118%' 
									
										or 
									
									upper(Sizelist) LIKE '%9%' 
									
										or 
									
									upper(Sizelist) LIKE '%90%' 
									)
							 GROUP BY STYLE_ID
		ORDER BY min(sortposition)
		

		SELECT * FROM 	
		GetALLProducts223  ORDER BY
		 RealName 

		SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(attr1list) as attr1list
		, max(famlist) as famlist
		, max(sizelist) as sizelist
		, max(name) as name
		, max(gender) as gender
		, max(hexlist) as hexlist
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		, max(of1) as of1
        , max(of2) as of2
        , max(of3) as of3
        , max(of4) as of4
        , max(of5) as of5
        , max(of6) as of6
        , max(of7) as of7
        , max(of8) as of8
        , max(of9) as of9
        , max(of10) as of10
		, max(of11) as of11
		, max(of12) as of12
		, max(of13) as of13
		, max(of14) as of14
		, max(of15) as of15
		, max(of16) as of16
		, max(of17) as of17
		, max(of18) as of18
		, max(of19) as of19
		, max(of20) as of20
        , max(WEB_OF1) as WEB_OF1
        , max(WEB_OF2) as WEB_OF2
        , max(WEB_OF3) as WEB_OF3
        , max(WEB_OF4) as WEB_OF4
        , max(WEB_OF5) as WEB_OF5
        , max(WEB_OF6) as WEB_OF6
        , max(WEB_OF7) as WEB_OF7
        , max(WEB_OF8) as WEB_OF8
        , max(WEB_OF9) as WEB_OF9
        , max(WEB_OF10) as WEB_OF10
        , max(WEB_OF11) as WEB_OF11
        , max(WEB_OF12) as WEB_OF12 
        , max(WEB_OF13) as WEB_OF13
        , max(WEB_OF14) as WEB_OF14
        , max(WEB_OF15) as WEB_OF15
        , max(WEB_OF16) as WEB_OF16
        , max(WEB_OF17) as WEB_OF17
        , max(WEB_OF18) as WEB_OF18
        , max(WEB_OF19) as WEB_OF19
        , max(WEB_OF20) as WEB_OF20
		
		FROM [dbo].[web_all_products] 
        WHERE pictureid is not null

		
			and ltrim(rtrim(dept))='Snowboarding'
		GROUP BY STYLE_ID 

		SELECT * FROM GetALLBrands223 ORDER BY
		sortposition asc 

          select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='snowboarding'
          

		select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='snowboarding'
		

				SELECT typ, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Snowboarding' and typ>'' and subtyp_1='EMPTY' and typ<>'EMPTY' 
                ORDER BY sort_position
			

				SELECT DISTINCT typ, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='SNOWBOARDING' and upper(typ)<>'EMPTY' and style_id IN (413775,446352,455657,455659,455662,455721,445947,445937,455660,455661,455695,455697,455722,455713,455715,455704,455705,455706,455708,445942,445944,455716,455717,455725,445939,455664,455665,455723,455699,455700,445935,456702,455655,445943,455711,436158,455710,455702,454503,454499,454060,454502,454117,454199,454200,438623,453233,453236,438619,453240,453241,453242,454058,454061,438620,438613,438614,453243,438618,453230,453231,438616,453229,438622,438615,453228,438610,438611,438609,453238,453239,453227,453226,453225,432640,438605,453244,453245,438604,446297,437272,357208,357207,437273,446996,446995,446997,446994,456717,456721,447009,456720,437041,447008,447010,447007,447002,437039,447006,456718,456719,394472,414228,447031,457363,424005,457361,437554,457354,457360,447021,457366,446965,437553,447411,437552,446967,457365,457362,437561,447027,457371,447026,425081,414231,446961,446966,447023,457357,457358,446771,446769,446770,446777,437264,447011,413636,413638,437265,447014,437263,447012,437261,437260,432202,432207,413575,446780,413589,424407,436116,424396,446786,446787,424371,413609,446801,446802,446785,447771,436130,436461,413588,446790,413613,446803,446789,446788,424375,413592,436123,413591,446794,436121,436122,446791,446792,446793,413615,446804,446805,413603,436126,436127,436460,446795,446796,446797,436133,446806,446807,446798,446799,446800,424388,413619,436134,446808,424406,436112,446782,446783,436071,413583,436114,446784,436113,446781,436110,413576,445475,445517,445518,445519,445560,445520,445532,445534,445533,445537,445538,412417,410324,444981) 
                GROUP BY typ
			

        SELECT brand,branddisplay, count(distinct
        
          style_id
        
        ) as itemCount 
        FROM getproducts 
        WHERE brand >'' 
        and upper(dept)='SNOWBOARDING'   
        GROUP BY brand,branddisplay 
        ORDER BY brand asc
        

                SELECT pricerange as price, count(distinct
                
                style_id
                
                ) as itemCount FROM getproducts 
                WHERE pricerange > ''
                 and upper(dept)='SNOWBOARDING'   
                GROUP BY pricerange 
                ORDER BY pricerange ASC
                

                SELECT * FROM temp ORDER BY ranking ASC
                

            select distinct FAMLIST, count(distinct
            
            style_id
            
            ) as itemcount 
            FROM getproducts 
            where FAMLIST<>'' and style_id <> 252213
             and upper(dept)='SNOWBOARDING'   
            GROUP BY FAMLIST
            

                  select distinct sizeList 
                  from getproducts 
                  where sizeList <>''  
                   and upper(dept)='SNOWBOARDING'   
                  group by sizeList
                  

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 413775
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=413775
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=413775 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 446352
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=446352
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=446352 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455657
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455657
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455657 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455659
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455659
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455659 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455662
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455662
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455662 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455721
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455721
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455721 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445947
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445947
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445947 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445937
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445937
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445937 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455660
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455660
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455660 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455661
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455661
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455661 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455695
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455695
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455695 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455697
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455697
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455697 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455722
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455722
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455722 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455713
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455713
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455713 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455715
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455715
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455715 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455704
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455704
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455704 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455705
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455705
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455705 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455706
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455706
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455706 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455708
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455708
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455708 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445942
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445942
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445942 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 445944
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=445944
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=445944 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455716
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455716
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455716 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455717
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455717
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455717 
          ORDER BY a.term_sale_id desc
		 

		select a.style_id, min(e.price) as minprice, max(e.price) as maxprice, max(e.first_price) as listprice , max(e.first_price) as firstPrice , max(e.sugg_price) as suggPrice , max(e.store_price) as storePrice
		from tb_skus a
		left join tb_sku_buckets e on (e.sku_id = a.sku_id)
		where a.style_id = 455725
		and e.store_id =90 
		group by a.style_id
		order by a.style_id
		

			SELECT	e.typ,e.amount,d.term_sale_id, e.from_price,e.rounding
			FROM	tb_styles a
			INNER JOIN	TB_TAXONOMY b ON a.TAXONOMY_ID = b.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALE_TAXONOMY c ON b.TAXONOMY_ID = c.TAXONOMY_ID
			INNER JOIN	TB_TERM_SALES d ON c.TERM_SALE_ID = d.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_SETTING e ON d.TERM_SALE_ID = e.TERM_SALE_ID
			INNER JOIN	TB_TERM_SALE_STORE f ON d.TERM_SALE_ID = f.TERM_SALE_ID
			WHERE	e.start_date<= '10/14/2024 23:59:00'
			AND	e.end_date >= '10/14/2024 23:59:00'
			AND	f.store_id=90
			AND	a.style_id=455725
			AND	d.approved='Y'
		

		  SELECT b.typ,b.amount,a.term_sale_id, a.term_sale_id, b.from_price , b.rounding
          FROM tb_term_sale_entries b 
          LEFT JOIN tb_term_sales a WITH (NOLOCK) ON (a.term_sale_id=b.term_sale_id)
          LEFT JOIN tb_styles c WITH (NOLOCK) ON (c.style_id=b.style_id)
		  WHERE b.start_date<= '2024-10-14 11:21:00' 
        	AND b.end_date >= '2024-10-14 11:21:00' 
            and (b.store_id=90 or ISNULL(b.store_id,'') = '')
			and b.style_id=455725 
          ORDER BY a.term_sale_id desc
		 

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35684555-EE35-F7BD-2C48AB815CFB5149') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3581E028-0BA8-C86F-CA4ECFC3081F3CF7') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3575014A-EDB6-21D0-51829D81B2081191') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35FD8DD0-ECD9-D4DB-CCB36427DF793CD8') AND (active = 1) AND display > 0
        

            SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '1A914999-DFE6-3992-87E5EB96B4418AC1') AND (active = 1) and display > 0
            ORDER BY orderno
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35E53A2F-C82C-4DE8-CDD02EAA62DE69C2') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '36560044-E1D3-8E01-AE5A2AC67D5BBCF0') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '367528A6-02D5-2606-1E8EAD27DFCF9231') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '36913E04-EBCB-DAB8-962FE7042A6EC031') AND (active = 1) AND display > 0
        

            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '369974F5-FEE3-6BF2-4BFB1627C1DFC7B2') AND (active = 1) AND display > 0
        

          					SELECT dept,web_url,sort_position, category_style 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position
          				

							select distinct dept from web_all_products group by dept
						

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='MENS' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='MENS' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Mens' 
		
					and EXISTS (
						SELECT 1
						FROM tb_skus c WITH (NOLOCK)
						LEFT JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id)
						LEFT JOIN tb_receiptline e WITH (NOLOCK) ON (d.sku_bucket_id = e.sku_bucket_id)
						LEFT JOIN tb_receipt f WITH (NOLOCK) ON (e.receipt_num = f.receipt_num)
						WHERE c.style_id = a.style_id
							AND dateDiff(day,getDate(),f.date_time) < 30
					)
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='WOMENS' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='WOMENS' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SWIM' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SWIM' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='DRESSES/ROMPERS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='DRESSES/ROMPERS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Womens' 
		
					and a.sale='Y'
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Womens' 
		
					and EXISTS (
						SELECT 1
						FROM tb_skus c WITH (NOLOCK)
						LEFT JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id)
						LEFT JOIN tb_receiptline e WITH (NOLOCK) ON (d.sku_bucket_id = e.sku_bucket_id)
						LEFT JOIN tb_receipt f WITH (NOLOCK) ON (e.receipt_num = f.receipt_num)
						WHERE c.style_id = a.style_id
							AND dateDiff(day,getDate(),f.date_time) < 30
					)
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

				SELECT *, 1 as querySort
				FROM firstQuery
				UNION
				SELECT *, 2 as querySort
				FROM getFiller
				ORDER BY querySort, sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='KIDS' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='KIDS' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOYS' and upper(dept)='KIDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOYS' and upper(dept)='KIDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='GIRLS' and upper(dept)='KIDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GIRLS' and upper(dept)='KIDS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Kids' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='FOOTWEAR' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='FOOTWEAR' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='FOOTWEAR' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='FOOTWEAR'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='FOOTWEAR' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='FOOTWEAR'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Footwear' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='SKATEBOARDS' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SKATEBOARDS' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='COMPLETE SKATEBOARDS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='COMPLETE SKATEBOARDS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='PARTS AND ACCESSORIES' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PARTS AND ACCESSORIES' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD TRUCKS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD TRUCKS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD DECKS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD DECKS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD WHEELS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD WHEELS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='PROTECTIVE GEAR' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PROTECTIVE GEAR' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='LONGBOARDS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LONGBOARDS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD BEARINGS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD BEARINGS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='GRIPTAPE' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GRIPTAPE' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATES' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATES' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Skateboards' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='SURF SHOP' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SURF SHOP' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SURFBOARDS' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SURFBOARDS' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SURF ACCESSORIES' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SURF ACCESSORIES' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BODYBOARDING' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BODYBOARDING' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='STAND UP PADDLE' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='STAND UP PADDLE' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='DIVE' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='DIVE' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='LYCRA' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LYCRA' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WETSUITS' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WETSUITS' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Surf Shop' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='SNOWBOARDING' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SNOWBOARDING' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BINDINGS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BINDINGS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BOOTS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BOOTS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='GOGGLES' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GOGGLES' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD HELMETS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD HELMETS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BAGS AND PACKS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BAGS AND PACKS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARDS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARDS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD ACCESSORIES' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD ACCESSORIES' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Snowboarding' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
										ORDER BY sort_position
									

											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
											group by typ
										

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BACKPACKS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BACKPACKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BAGS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BAGS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BEANIES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BEANIES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='HAIR CARE' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='HAIR CARE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='HATS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='HATS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='JEWELRY' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='JEWELRY' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='PURSES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PURSES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SOCKS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SOCKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SUNGLASSES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SUNGLASSES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SUNSCREEN/SKIN CARE' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SUNSCREEN/SKIN CARE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WALLETS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WALLETS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WATCHES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WATCHES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='FACEMASKS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='FACEMASKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='STICKERS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='STICKERS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOXERS/BRIEFS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOXERS/BRIEFS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WATER BOTTLES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WATER BOTTLES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BEACH TOWELS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BEACH TOWELS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='COOLERS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='COOLERS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BELTS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BELTS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='LUGGAGE' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		

																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LUGGAGE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		

		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Accessories' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		

				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			

          					SELECT dept,web_url,sort_position 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position
          		

                                    SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY'
                                    ORDER BY sort_position
                    			

Application Variables:
accuratetaxchecksum=
accuratetaxlicensekey=
addtocarturl=https://www.bcsurf.com/
adminurl=https://www.bcsurf.com/web_admin/products/menu.cfm?style_id=
adwordsid=
allow_out_of_stock=NO
allow_sell_out_of_stock=NO
allow_show_out_of_stock=NO
altimgdir=D:\websites\prodimages\alt_images\
amazoncheckout=Struct (1)
applicationname=AppCFC
attr1_name=Color
attr2_name=Option
authorizenet=Struct (3)
bannerdir=D:\websites\images\banners\
bingverificationstr=
blogurl=
breakoutsizes=false
cms=muraDB
companyname=BC Surf & Sport
dbname=celerant
display_ship_methods=true
displaycount=24
displaypercentage=5
domesticshippingonly=false
ds=koalaSQL
egiftcardshippingmethodid=1
facebookurl=
fedex=Struct (12)
feedsdir=D:\websites\feeds\
filterlist=Price,Brand,Sale,New,Color,Size,length,test
forumemail=customerservice@bcsurf.com
freeshippingthreshold=50
fullauth=true
getwebtaxonomy=Query (272)
giftcardimgpath=file:///D:\websites\images/
giftcardpdfpath=D:\websites\giftcardPDF\
giftcardurl=https://www.bcsurf.com/info/e-gift-certificate
googleadwords=true
googleanalytics=true
googleanalyticsid=UA-2790860-5
googlecheckout=Struct (21)
googlefeedproducttype=Apparel & Accessories > Clothing
googleplusurl=
googleverificationstr=
homeurl=https://www.bcsurf.com/
imagedir=D:\websites\images\
instagramurl=
instockmsg=In-Stock
internationalcheckout=Struct (2)
invoverride=ALWAYS IN,DROP SHIP ITEM
isapirewritedir=C:\Program Files\Helicon\ISAPI_Rewrite3\
iscelerantactive=true
iscmsactive=false
isstorelocationsdbactive=false
largeprodimgdim=Struct (2)
locationdsdb=STORE_LOCATIONS
logdir=D:\websites\logs\
machine_id=8900
mailport=25
mailserver=127.0.0.1
medprodimgdim=Struct (2)
metadesc=
metatags=
multiplesitelist=/
mydomain=
orderemails=customerservice@bcsurf.com
outofstockmsg=Out of Stock
outofstockthreshold=0
packageid=0
packagetype=UNIVERSAL
pagetitle=BC Surf & Sport- Skate,Surf,Snowboard across the country since 1977
paypalconfig=Struct (11)
pinteresturl=
prefguestid=
pricing_store=90
prodimgdir=D:\websites\prodimages\
productreviews=true
qoh_store=ALL
quickcharge=Struct (6)
recaptcha=Struct (3)
receipttyp=SPECORDER
salesemail=customerservice@bcsurf.com
secureurl=https://www.bcsurf.com/
shiptomilitary=true
shiptostoreshippingmethodid=1
showattr1=true
showattr2=true
showsize=true
siteid=1
sitephone=800-528-9061
size_name=Size
smallprodimgdim=Struct (2)
speclist=length,test
startshoppingurl=https://www.bcsurf.com/
store=90
storelocator=false
supportemail=customerservice@bcsurf.com
tinyprodimgdim=Struct (2)
tsys=Struct (16)
twittername=
twitterurl=
ups=Struct (11)
use301redirects=false
use_authorizenet=true
use_avatax=false
use_celerant_shipping_rates=true
use_celerant_ups_live_rates=ON
use_dimensions=true
use_fedex_live_rates=false
use_giftcards=true
use_only_giftcards=true
use_quickcharge=false
use_ship_tax_codes=true
use_tsys=false
use_ups_live_rates=true
use_usps_live_rates=true
useaccuratetax=false
useamazoncheckout=false
usecelerantstorelocations=false
usegiftcerticates=true
usegooglecheckout=false
usepackages=false
usepaypal=true
usesavedcart=true
useshiptostore=true
usewebstylegrouping=false
usewishlists=true
usps=Struct (6)
util=Struct (26)
viewnosellmsg=Out of Stock
webadminurl=https://www.bcsurf.com/web_admin/
webroot=D:\websites\
websitename=BC Surf & Sport
wishlistemail=customerservice@bcsurf.com
wishlistphone=800-528-9061
woeurl=https://www.bcsurf.com/woe/
yahooverificationstr=
youtubeurl=

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=CN=www.bcsurf.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\websites\defaultWebsite\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=Sectigo Limited, CN=Sectigo RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=CN=www.bcsurf.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.bcsurf.com
HTTP_REFERER=https://bcsurf.com/snowboarding/browse/size/11,6|7,6,118,9,90
HTTP_URL=/category.cfm?mapping=snowboarding/browse/size/11,6|7,6,118,9,90
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=192.168.50.200
PATH_INFO=
PATH_TRANSLATED=D:\websites\defaultWebsite\category.cfm
QUERY_STRING=mapping=snowboarding/browse/size/11,6|7,6,118,9,90
REMOTE_ADDR=3.135.196.172
REMOTE_HOST=3.135.196.172
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.bcsurf.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
cfid=4002
cftoken=b19b1b518da33ded-74333350-B3BB-590C-035D166797E94283

Form Fields:
KWORD=

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
altimgurl=https://www.bcsurf.com/prodimages/alt_images/
cartstatus=NEW
cfid=4002
cftoken=b19b1b518da33ded-74333350-B3BB-590C-035D166797E94283
checkout=Struct (4)
couponreset=NO
cs=https://www.bcsurf.com/snowboarding/browse/size/11,6|7,6,118,9,90
customer_id=
customerdiscount=0
display_cc=YES
displaycount=24
email=
employeeloggedin=false
first_name=
iconurl=https://www.bcsurf.com/images/icons/
last_name=
memberloggedin=N
myreturnurl=https://www.bcsurf.com/snowboarding/browse/size/11,6|7,6,118,9,90
password=
phone=
picurl=https://www.bcsurf.com/images/
prodimgurl=https://www.bcsurf.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_4002_b19b1b518da33ded-74333350-B3BB-590C-035D166797E94283
shipmethodlist=0,1
urltoken=CFID=4002&CFTOKEN=b19b1b518da33ded-74333350-B3BB-590C-035D166797E94283
username=
website=Struct (1)

URL Parameters:
mapping=snowboarding/browse/size/11,6|7,6,118,9,90